Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 188375 |
| Missing cells | 815752 |
| Missing cells (%) | 17.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 35.9 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 17 |
sueldo_smdlv is highly correlated with otros_ingresos_smdlv and 1 other fields | High correlation |
otros_ingresos_smdlv is highly correlated with sueldo_smdlv | High correlation |
año_credito is highly correlated with sueldo_smdlv | High correlation |
sueldo_smdlv is highly correlated with otros_ingresos_smdlv and 1 other fields | High correlation |
otros_ingresos_smdlv is highly correlated with sueldo_smdlv | High correlation |
año_credito is highly correlated with sueldo_smdlv | High correlation |
valor_credito_smdlv is highly correlated with cuotas | High correlation |
cuotas is highly correlated with valor_credito_smdlv | High correlation |
municipio_credito is highly correlated with municipio_expedicion and 2 other fields | High correlation |
municipio_expedicion is highly correlated with municipio_credito and 3 other fields | High correlation |
año_credito is highly correlated with Row and 2 other fields | High correlation |
forma_pago is highly correlated with sector | High correlation |
municipio_nacimiento is highly correlated with municipio_credito and 3 other fields | High correlation |
Row is highly correlated with municipio_expedicion and 6 other fields | High correlation |
periodo_credito is highly correlated with Row | High correlation |
genero is highly correlated with Row | High correlation |
codeudor is highly correlated with Row | High correlation |
otros_ingresos_smdlv is highly correlated with año_credito and 1 other fields | High correlation |
tipo_cliente is highly correlated with estado_final | High correlation |
sueldo_smdlv is highly correlated with año_credito and 1 other fields | High correlation |
sector is highly correlated with forma_pago | High correlation |
estado_final is highly correlated with tipo_cliente | High correlation |
municipio_residencia is highly correlated with municipio_credito and 3 other fields | High correlation |
municipio_credito is highly correlated with municipio_residencia | High correlation |
tipo_cliente is highly correlated with estado_final | High correlation |
municipio_expedicion is highly correlated with municipio_nacimiento | High correlation |
tipo_persona is highly correlated with genero | High correlation |
forma_pago is highly correlated with sector | High correlation |
municipio_nacimiento is highly correlated with municipio_expedicion | High correlation |
sector is highly correlated with forma_pago | High correlation |
genero is highly correlated with tipo_persona | High correlation |
estado_final is highly correlated with tipo_cliente | High correlation |
municipio_residencia is highly correlated with municipio_credito | High correlation |
genero has 101176 (53.7%) missing values | Missing |
estado_civil has 106039 (56.3%) missing values | Missing |
edad has 111303 (59.1%) missing values | Missing |
municipio_expedicion has 95331 (50.6%) missing values | Missing |
tiene_casa_propia has 104056 (55.2%) missing values | Missing |
sueldo_smdlv has 114766 (60.9%) missing values | Missing |
otros_ingresos_smdlv has 182980 (97.1%) missing values | Missing |
Row is uniformly distributed | Uniform |
Row has unique values | Unique |
Reproduction
| Analysis started | 2021-05-19 19:24:01.779310 |
|---|---|
| Analysis finished | 2021-05-19 19:25:06.871959 |
| Duration | 1 minute and 5.09 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 188375 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94188 |
| Minimum | 1 |
|---|---|
| Maximum | 188375 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9419.7 |
| Q1 | 47094.5 |
| median | 94188 |
| Q3 | 141281.5 |
| 95-th percentile | 178956.3 |
| Maximum | 188375 |
| Range | 188374 |
| Interquartile range (IQR) | 94187 |
Descriptive statistics
| Standard deviation | 54379.32282 |
|---|---|
| Coefficient of variation (CV) | 0.5773487367 |
| Kurtosis | -1.2 |
| Mean | 94188 |
| Median Absolute Deviation (MAD) | 47094 |
| Skewness | 0 |
| Sum | 1.77426645 × 1010 |
| Variance | 2957110750 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2047 | 1 | < 0.1% |
| 136552 | 1 | < 0.1% |
| 157030 | 1 | < 0.1% |
| 163173 | 1 | < 0.1% |
| 161124 | 1 | < 0.1% |
| 150883 | 1 | < 0.1% |
| 148834 | 1 | < 0.1% |
| 154977 | 1 | < 0.1% |
| 152928 | 1 | < 0.1% |
| 44351 | 1 | < 0.1% |
| Other values (188365) | 188365 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 188375 | 1 | |
| 188374 | 1 | |
| 188373 | 1 | |
| 188372 | 1 | |
| 188371 | 1 | |
| 188370 | 1 | |
| 188369 | 1 | |
| 188368 | 1 | |
| 188367 | 1 | |
| 188366 | 1 |
procedencia
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Nacional | |
|---|---|
| Extranjero | 155 |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 8.001645654 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1507310 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nacional |
|---|---|
| 2nd row | Nacional |
| 3rd row | Nacional |
| 4th row | Nacional |
| 5th row | Nacional |
Common Values
| Value | Count | Frequency (%) |
| Nacional | 188220 | |
| Extranjero | 155 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| nacional | 188220 | |
| extranjero | 155 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 376595 | |
| o | 188375 | |
| n | 188375 | |
| N | 188220 | |
| c | 188220 | |
| i | 188220 | |
| l | 188220 | |
| r | 310 | < 0.1% |
| E | 155 | < 0.1% |
| x | 155 | < 0.1% |
| Other values (3) | 465 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1318935 | |
| Uppercase Letter | 188375 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 376595 | |
| o | 188375 | |
| n | 188375 | |
| c | 188220 | |
| i | 188220 | |
| l | 188220 | |
| r | 310 | < 0.1% |
| x | 155 | < 0.1% |
| t | 155 | < 0.1% |
| j | 155 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 188220 | |
| E | 155 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1507310 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 376595 | |
| o | 188375 | |
| n | 188375 | |
| N | 188220 | |
| c | 188220 | |
| i | 188220 | |
| l | 188220 | |
| r | 310 | < 0.1% |
| E | 155 | < 0.1% |
| x | 155 | < 0.1% |
| Other values (3) | 465 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1507310 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 376595 | |
| o | 188375 | |
| n | 188375 | |
| N | 188220 | |
| c | 188220 | |
| i | 188220 | |
| l | 188220 | |
| r | 310 | < 0.1% |
| E | 155 | < 0.1% |
| x | 155 | < 0.1% |
| Other values (3) | 465 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 101176 |
| Missing (%) | 53.7% |
| Memory size | 1.4 MiB |
| Femenino | |
|---|---|
| Masculino |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.462184199 |
| Min length | 8 |
Characters and Unicode
| Total characters | 737894 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Femenino |
|---|---|
| 2nd row | Femenino |
| 3rd row | Femenino |
| 4th row | Femenino |
| 5th row | Femenino |
Common Values
| Value | Count | Frequency (%) |
| Femenino | 46897 | |
| Masculino | 40302 | 21.4% |
| (Missing) | 101176 |
Length
Pie chart
| Value | Count | Frequency (%) |
| femenino | 46897 | |
| masculino | 40302 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 134096 | |
| e | 93794 | |
| i | 87199 | |
| o | 87199 | |
| F | 46897 | 6.4% |
| m | 46897 | 6.4% |
| M | 40302 | 5.5% |
| a | 40302 | 5.5% |
| s | 40302 | 5.5% |
| c | 40302 | 5.5% |
| Other values (2) | 80604 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 650695 | |
| Uppercase Letter | 87199 | 11.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 134096 | |
| e | 93794 | |
| i | 87199 | |
| o | 87199 | |
| m | 46897 | 7.2% |
| a | 40302 | 6.2% |
| s | 40302 | 6.2% |
| c | 40302 | 6.2% |
| u | 40302 | 6.2% |
| l | 40302 | 6.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 46897 | |
| M | 40302 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 737894 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 134096 | |
| e | 93794 | |
| i | 87199 | |
| o | 87199 | |
| F | 46897 | 6.4% |
| m | 46897 | 6.4% |
| M | 40302 | 5.5% |
| a | 40302 | 5.5% |
| s | 40302 | 5.5% |
| c | 40302 | 5.5% |
| Other values (2) | 80604 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 737894 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 134096 | |
| e | 93794 | |
| i | 87199 | |
| o | 87199 | |
| F | 46897 | 6.4% |
| m | 46897 | 6.4% |
| M | 40302 | 5.5% |
| a | 40302 | 5.5% |
| s | 40302 | 5.5% |
| c | 40302 | 5.5% |
| Other values (2) | 80604 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 106039 |
| Missing (%) | 56.3% |
| Memory size | 1.4 MiB |
| Union Libre | |
|---|---|
| Casado | |
| Soltero | |
| Viudo | 809 |
| Divorciado | 462 |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 8.257979499 |
| Min length | 5 |
Characters and Unicode
| Total characters | 679929 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Union Libre |
|---|---|
| 2nd row | Union Libre |
| 3rd row | Union Libre |
| 4th row | Union Libre |
| 5th row | Soltero |
Common Values
| Value | Count | Frequency (%) |
| Union Libre | 32146 | 17.1% |
| Casado | 24775 | 13.2% |
| Soltero | 24144 | 12.8% |
| Viudo | 809 | 0.4% |
| Divorciado | 462 | 0.2% |
| (Missing) | 106039 |
Length
Pie chart
| Value | Count | Frequency (%) |
| union | 32146 | |
| libre | 32146 | |
| casado | 24775 | |
| soltero | 24144 | |
| viudo | 809 | 0.7% |
| divorciado | 462 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 106942 | |
| i | 66025 | |
| n | 64292 | |
| r | 56752 | 8.3% |
| e | 56290 | 8.3% |
| a | 50012 | 7.4% |
| U | 32146 | 4.7% |
| 32146 | 4.7% | |
| L | 32146 | 4.7% |
| b | 32146 | 4.7% |
| Other values (11) | 151032 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 533301 | |
| Uppercase Letter | 114482 | 16.8% |
| Space Separator | 32146 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 106942 | |
| i | 66025 | |
| n | 64292 | |
| r | 56752 | |
| e | 56290 | |
| a | 50012 | |
| b | 32146 | 6.0% |
| d | 26046 | 4.9% |
| s | 24775 | 4.6% |
| l | 24144 | 4.5% |
| Other values (4) | 25877 | 4.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 32146 | |
| L | 32146 | |
| C | 24775 | |
| S | 24144 | |
| V | 809 | 0.7% |
| D | 462 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 32146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 647783 | |
| Common | 32146 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 106942 | |
| i | 66025 | |
| n | 64292 | |
| r | 56752 | |
| e | 56290 | |
| a | 50012 | |
| U | 32146 | 5.0% |
| L | 32146 | 5.0% |
| b | 32146 | 5.0% |
| d | 26046 | 4.0% |
| Other values (10) | 124986 |
Common
| Value | Count | Frequency (%) |
| 32146 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 679929 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 106942 | |
| i | 66025 | |
| n | 64292 | |
| r | 56752 | 8.3% |
| e | 56290 | 8.3% |
| a | 50012 | 7.4% |
| U | 32146 | 4.7% |
| 32146 | 4.7% | |
| L | 32146 | 4.7% |
| b | 32146 | 4.7% |
| Other values (11) | 151032 |
| Distinct | 72 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 111303 |
| Missing (%) | 59.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.54414054 |
| Minimum | 18 |
|---|---|
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 35 |
| median | 44 |
| Q3 | 53 |
| 95-th percentile | 65 |
| Maximum | 90 |
| Range | 72 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 11.8598161 |
|---|---|
| Coefficient of variation (CV) | 0.2662486233 |
| Kurtosis | -0.3854007273 |
| Mean | 44.54414054 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.3212489544 |
| Sum | 3433106 |
| Variance | 140.6552378 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 2968 | 1.6% |
| 40 | 2611 | 1.4% |
| 45 | 2461 | 1.3% |
| 41 | 2454 | 1.3% |
| 49 | 2371 | 1.3% |
| 46 | 2341 | 1.2% |
| 35 | 2314 | 1.2% |
| 42 | 2231 | 1.2% |
| 37 | 2215 | 1.2% |
| 31 | 2153 | 1.1% |
| Other values (62) | 52953 | |
| (Missing) | 111303 |
| Value | Count | Frequency (%) |
| 18 | 6 | < 0.1% |
| 19 | 31 | < 0.1% |
| 20 | 133 | 0.1% |
| 21 | 207 | 0.1% |
| 22 | 329 | 0.2% |
| 23 | 449 | 0.2% |
| 24 | 558 | |
| 25 | 885 | |
| 26 | 1033 | |
| 27 | 1204 |
| Value | Count | Frequency (%) |
| 90 | 2 | < 0.1% |
| 89 | 1 | < 0.1% |
| 88 | 2 | < 0.1% |
| 87 | 1 | < 0.1% |
| 85 | 14 | < 0.1% |
| 84 | 41 | |
| 83 | 48 | |
| 82 | 20 | |
| 81 | 49 | |
| 80 | 44 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| ARAUCA | |
|---|---|
| TAME | |
| SARAVENA | |
| Otros | |
| ARAUQUITA |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.81710418 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1095797 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SARAVENA |
|---|---|
| 2nd row | SARAVENA |
| 3rd row | ARAUCA |
| 4th row | SARAVENA |
| 5th row | SARAVENA |
Common Values
| Value | Count | Frequency (%) |
| ARAUCA | 77888 | |
| TAME | 57185 | |
| SARAVENA | 29961 | 15.9% |
| Otros | 12507 | 6.6% |
| ARAUQUITA | 10834 | 5.8% |
Length
Pie chart
| Value | Count | Frequency (%) |
| arauca | 77888 | |
| tame | 57185 | |
| saravena | 29961 | 15.9% |
| otros | 12507 | 6.6% |
| arauquita | 10834 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 413234 | |
| R | 118683 | 10.8% |
| U | 99556 | 9.1% |
| E | 87146 | 8.0% |
| C | 77888 | 7.1% |
| T | 68019 | 6.2% |
| M | 57185 | 5.2% |
| S | 29961 | 2.7% |
| V | 29961 | 2.7% |
| N | 29961 | 2.7% |
| Other values (7) | 84203 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1045769 | |
| Lowercase Letter | 50028 | 4.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 413234 | |
| R | 118683 | 11.3% |
| U | 99556 | 9.5% |
| E | 87146 | 8.3% |
| C | 77888 | 7.4% |
| T | 68019 | 6.5% |
| M | 57185 | 5.5% |
| S | 29961 | 2.9% |
| V | 29961 | 2.9% |
| N | 29961 | 2.9% |
| Other values (3) | 34175 | 3.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 12507 | |
| r | 12507 | |
| o | 12507 | |
| s | 12507 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1095797 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 413234 | |
| R | 118683 | 10.8% |
| U | 99556 | 9.1% |
| E | 87146 | 8.0% |
| C | 77888 | 7.1% |
| T | 68019 | 6.2% |
| M | 57185 | 5.2% |
| S | 29961 | 2.7% |
| V | 29961 | 2.7% |
| N | 29961 | 2.7% |
| Other values (7) | 84203 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1095797 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 413234 | |
| R | 118683 | 10.8% |
| U | 99556 | 9.1% |
| E | 87146 | 8.0% |
| C | 77888 | 7.1% |
| T | 68019 | 6.2% |
| M | 57185 | 5.2% |
| S | 29961 | 2.7% |
| V | 29961 | 2.7% |
| N | 29961 | 2.7% |
| Other values (7) | 84203 | 7.7% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 83 |
| Missing (%) | < 0.1% |
| Memory size | 1.4 MiB |
| ARAUCA | |
|---|---|
| Otros | |
| TAME | |
| ARAUQUITA | 8075 |
| SARAVENA | 6705 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.825489134 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1096893 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARAUCA |
|---|---|
| 2nd row | ARAUCA |
| 3rd row | ARAUCA |
| 4th row | ARAUCA |
| 5th row | ARAUCA |
Common Values
| Value | Count | Frequency (%) |
| ARAUCA | 122001 | |
| Otros | 32528 | 17.3% |
| TAME | 18983 | 10.1% |
| ARAUQUITA | 8075 | 4.3% |
| SARAVENA | 6705 | 3.6% |
| (Missing) | 83 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| arauca | 122001 | |
| otros | 32528 | 17.3% |
| tame | 18983 | 10.1% |
| arauquita | 8075 | 4.3% |
| saravena | 6705 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 429326 | |
| U | 138151 | 12.6% |
| R | 136781 | 12.5% |
| C | 122001 | 11.1% |
| O | 32528 | 3.0% |
| t | 32528 | 3.0% |
| r | 32528 | 3.0% |
| o | 32528 | 3.0% |
| s | 32528 | 3.0% |
| T | 27058 | 2.5% |
| Other values (7) | 80936 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 966781 | |
| Lowercase Letter | 130112 | 11.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 429326 | |
| U | 138151 | 14.3% |
| R | 136781 | 14.1% |
| C | 122001 | 12.6% |
| O | 32528 | 3.4% |
| T | 27058 | 2.8% |
| E | 25688 | 2.7% |
| M | 18983 | 2.0% |
| Q | 8075 | 0.8% |
| I | 8075 | 0.8% |
| Other values (3) | 20115 | 2.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 32528 | |
| r | 32528 | |
| o | 32528 | |
| s | 32528 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1096893 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 429326 | |
| U | 138151 | 12.6% |
| R | 136781 | 12.5% |
| C | 122001 | 11.1% |
| O | 32528 | 3.0% |
| t | 32528 | 3.0% |
| r | 32528 | 3.0% |
| o | 32528 | 3.0% |
| s | 32528 | 3.0% |
| T | 27058 | 2.5% |
| Other values (7) | 80936 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1096893 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 429326 | |
| U | 138151 | 12.6% |
| R | 136781 | 12.5% |
| C | 122001 | 11.1% |
| O | 32528 | 3.0% |
| t | 32528 | 3.0% |
| r | 32528 | 3.0% |
| o | 32528 | 3.0% |
| s | 32528 | 3.0% |
| T | 27058 | 2.5% |
| Other values (7) | 80936 | 7.4% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 95331 |
| Missing (%) | 50.6% |
| Memory size | 1.4 MiB |
| ARAUCA | |
|---|---|
| Otros | |
| TAME | |
| ARAUQUITA | |
| SARAVENA | 3324 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.614204033 |
| Min length | 4 |
Characters and Unicode
| Total characters | 522368 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARAUCA |
|---|---|
| 2nd row | ARAUCA |
| 3rd row | ARAUCA |
| 4th row | ARAUCA |
| 5th row | ARAUCA |
Common Values
| Value | Count | Frequency (%) |
| ARAUCA | 37987 | 20.2% |
| Otros | 30902 | 16.4% |
| TAME | 14827 | 7.9% |
| ARAUQUITA | 6004 | 3.2% |
| SARAVENA | 3324 | 1.8% |
| (Missing) | 95331 |
Length
Pie chart
| Value | Count | Frequency (%) |
| arauca | 37987 | |
| otros | 30902 | |
| tame | 14827 | 15.9% |
| arauquita | 6004 | 6.5% |
| saravena | 3324 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 156772 | |
| U | 49995 | 9.6% |
| R | 47315 | 9.1% |
| C | 37987 | 7.3% |
| O | 30902 | 5.9% |
| t | 30902 | 5.9% |
| r | 30902 | 5.9% |
| o | 30902 | 5.9% |
| s | 30902 | 5.9% |
| T | 20831 | 4.0% |
| Other values (7) | 54958 | 10.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 398760 | |
| Lowercase Letter | 123608 | 23.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 156772 | |
| U | 49995 | 12.5% |
| R | 47315 | 11.9% |
| C | 37987 | 9.5% |
| O | 30902 | 7.7% |
| T | 20831 | 5.2% |
| E | 18151 | 4.6% |
| M | 14827 | 3.7% |
| Q | 6004 | 1.5% |
| I | 6004 | 1.5% |
| Other values (3) | 9972 | 2.5% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 30902 | |
| r | 30902 | |
| o | 30902 | |
| s | 30902 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 522368 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 156772 | |
| U | 49995 | 9.6% |
| R | 47315 | 9.1% |
| C | 37987 | 7.3% |
| O | 30902 | 5.9% |
| t | 30902 | 5.9% |
| r | 30902 | 5.9% |
| o | 30902 | 5.9% |
| s | 30902 | 5.9% |
| T | 20831 | 4.0% |
| Other values (7) | 54958 | 10.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 522368 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 156772 | |
| U | 49995 | 9.6% |
| R | 47315 | 9.1% |
| C | 37987 | 7.3% |
| O | 30902 | 5.9% |
| t | 30902 | 5.9% |
| r | 30902 | 5.9% |
| o | 30902 | 5.9% |
| s | 30902 | 5.9% |
| T | 20831 | 4.0% |
| Other values (7) | 54958 | 10.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Natural | |
|---|---|
| Juridica | 3540 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.018792303 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1322165 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Natural |
|---|---|
| 2nd row | Natural |
| 3rd row | Natural |
| 4th row | Natural |
| 5th row | Natural |
Common Values
| Value | Count | Frequency (%) |
| Natural | 184835 | |
| Juridica | 3540 | 1.9% |
Length
Pie chart
| Value | Count | Frequency (%) |
| natural | 184835 | |
| juridica | 3540 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 373210 | |
| u | 188375 | |
| r | 188375 | |
| N | 184835 | |
| t | 184835 | |
| l | 184835 | |
| i | 7080 | 0.5% |
| J | 3540 | 0.3% |
| d | 3540 | 0.3% |
| c | 3540 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1133790 | |
| Uppercase Letter | 188375 | 14.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 373210 | |
| u | 188375 | |
| r | 188375 | |
| t | 184835 | |
| l | 184835 | |
| i | 7080 | 0.6% |
| d | 3540 | 0.3% |
| c | 3540 | 0.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 184835 | |
| J | 3540 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1322165 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 373210 | |
| u | 188375 | |
| r | 188375 | |
| N | 184835 | |
| t | 184835 | |
| l | 184835 | |
| i | 7080 | 0.5% |
| J | 3540 | 0.3% |
| d | 3540 | 0.3% |
| c | 3540 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1322165 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 373210 | |
| u | 188375 | |
| r | 188375 | |
| N | 184835 | |
| t | 184835 | |
| l | 184835 | |
| i | 7080 | 0.5% |
| J | 3540 | 0.3% |
| d | 3540 | 0.3% |
| c | 3540 | 0.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 104056 |
| Missing (%) | 55.2% |
| Memory size | 1.4 MiB |
| Si | |
|---|---|
| No |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 168638 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No |
|---|---|
| 2nd row | No |
| 3rd row | No |
| 4th row | No |
| 5th row | Si |
Common Values
| Value | Count | Frequency (%) |
| Si | 61879 | |
| No | 22440 | 11.9% |
| (Missing) | 104056 |
Length
Pie chart
| Value | Count | Frequency (%) |
| si | 61879 | |
| no | 22440 | 26.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 61879 | |
| i | 61879 | |
| N | 22440 | 13.3% |
| o | 22440 | 13.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 84319 | |
| Lowercase Letter | 84319 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 61879 | |
| N | 22440 | 26.6% |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 61879 | |
| o | 22440 | 26.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 168638 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 61879 | |
| i | 61879 | |
| N | 22440 | 13.3% |
| o | 22440 | 13.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 168638 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 61879 | |
| i | 61879 | |
| N | 22440 | 13.3% |
| o | 22440 | 13.3% |
| Distinct | 520 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 114766 |
| Missing (%) | 60.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.9100246 |
| Minimum | 3 |
|---|---|
| Maximum | 600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 44 |
| median | 73 |
| Q3 | 130 |
| 95-th percentile | 291 |
| Maximum | 600 |
| Range | 597 |
| Interquartile range (IQR) | 86 |
Descriptive statistics
| Standard deviation | 90.84434247 |
|---|---|
| Coefficient of variation (CV) | 0.8742596571 |
| Kurtosis | 6.877685855 |
| Mean | 103.9100246 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 2.311806575 |
| Sum | 7648713 |
| Variance | 8252.694559 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 43 | 1634 | 0.9% |
| 34 | 1568 | 0.8% |
| 36 | 1485 | 0.8% |
| 46 | 1368 | 0.7% |
| 61 | 1366 | 0.7% |
| 38 | 1325 | 0.7% |
| 76 | 1316 | 0.7% |
| 69 | 1263 | 0.7% |
| 72 | 1224 | 0.6% |
| 30 | 1204 | 0.6% |
| Other values (510) | 59856 | |
| (Missing) | 114766 |
| Value | Count | Frequency (%) |
| 3 | 6 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 13 | < 0.1% |
| 6 | 21 | < 0.1% |
| 7 | 54 | < 0.1% |
| 8 | 25 | < 0.1% |
| 9 | 27 | < 0.1% |
| 10 | 135 | |
| 11 | 46 | < 0.1% |
| 12 | 45 | < 0.1% |
| Value | Count | Frequency (%) |
| 600 | 293 | |
| 599 | 1 | < 0.1% |
| 597 | 1 | < 0.1% |
| 593 | 1 | < 0.1% |
| 588 | 44 | < 0.1% |
| 586 | 6 | < 0.1% |
| 584 | 7 | < 0.1% |
| 582 | 10 | < 0.1% |
| 578 | 1 | < 0.1% |
| 576 | 15 | < 0.1% |
otros_ingresos
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| SIN OTROS INGRESOS | |
|---|---|
| CON OTROS INGRESOS | 5395 |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Characters and Unicode
| Total characters | 3390750 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SIN OTROS INGRESOS |
|---|---|
| 2nd row | SIN OTROS INGRESOS |
| 3rd row | SIN OTROS INGRESOS |
| 4th row | SIN OTROS INGRESOS |
| 5th row | SIN OTROS INGRESOS |
Common Values
| Value | Count | Frequency (%) |
| SIN OTROS INGRESOS | 182980 | |
| CON OTROS INGRESOS | 5395 | 2.9% |
Length
Pie chart
| Value | Count | Frequency (%) |
| ingresos | 188375 | |
| otros | 188375 | |
| sin | 182980 | |
| con | 5395 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 748105 | |
| O | 570520 | |
| N | 376750 | |
| 376750 | ||
| R | 376750 | |
| I | 371355 | |
| T | 188375 | 5.6% |
| G | 188375 | 5.6% |
| E | 188375 | 5.6% |
| C | 5395 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3014000 | |
| Space Separator | 376750 | 11.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 748105 | |
| O | 570520 | |
| N | 376750 | |
| R | 376750 | |
| I | 371355 | |
| T | 188375 | 6.2% |
| G | 188375 | 6.2% |
| E | 188375 | 6.2% |
| C | 5395 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 376750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3014000 | |
| Common | 376750 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 748105 | |
| O | 570520 | |
| N | 376750 | |
| R | 376750 | |
| I | 371355 | |
| T | 188375 | 6.2% |
| G | 188375 | 6.2% |
| E | 188375 | 6.2% |
| C | 5395 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 376750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3390750 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 748105 | |
| O | 570520 | |
| N | 376750 | |
| 376750 | ||
| R | 376750 | |
| I | 371355 | |
| T | 188375 | 5.6% |
| G | 188375 | 5.6% |
| E | 188375 | 5.6% |
| C | 5395 | 0.2% |
| Distinct | 212 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 182980 |
| Missing (%) | 97.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.5892493 |
| Minimum | 1 |
|---|---|
| Maximum | 300 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 20 |
| median | 34 |
| Q3 | 63 |
| 95-th percentile | 194 |
| Maximum | 300 |
| Range | 299 |
| Interquartile range (IQR) | 43 |
Descriptive statistics
| Standard deviation | 59.19009956 |
|---|---|
| Coefficient of variation (CV) | 1.084281252 |
| Kurtosis | 5.935529208 |
| Mean | 54.5892493 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 2.389772012 |
| Sum | 294509 |
| Variance | 3503.467886 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34 | 163 | 0.1% |
| 18 | 160 | 0.1% |
| 36 | 155 | 0.1% |
| 17 | 133 | 0.1% |
| 20 | 131 | 0.1% |
| 23 | 130 | 0.1% |
| 21 | 129 | 0.1% |
| 30 | 118 | 0.1% |
| 26 | 112 | 0.1% |
| 13 | 112 | 0.1% |
| Other values (202) | 4052 | 2.2% |
| (Missing) | 182980 |
| Value | Count | Frequency (%) |
| 1 | 7 | < 0.1% |
| 3 | 40 | |
| 4 | 42 | |
| 5 | 40 | |
| 6 | 50 | |
| 7 | 97 | |
| 8 | 66 | |
| 9 | 48 | |
| 10 | 94 | |
| 11 | 50 |
| Value | Count | Frequency (%) |
| 300 | 90 | |
| 294 | 8 | < 0.1% |
| 291 | 11 | < 0.1% |
| 288 | 3 | < 0.1% |
| 280 | 2 | < 0.1% |
| 276 | 1 | < 0.1% |
| 271 | 7 | < 0.1% |
| 268 | 2 | < 0.1% |
| 264 | 4 | < 0.1% |
| 262 | 2 | < 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| ARAUCA | |
|---|---|
| TAME | |
| SARAVENA | |
| ARAUQUITA | |
| Otros |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.928488388 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1116779 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SARAVENA |
|---|---|
| 2nd row | SARAVENA |
| 3rd row | ARAUCA |
| 4th row | SARAVENA |
| 5th row | ARAUQUITA |
Common Values
| Value | Count | Frequency (%) |
| ARAUCA | 77309 | |
| TAME | 50885 | |
| SARAVENA | 25064 | 13.3% |
| ARAUQUITA | 18322 | 9.7% |
| Otros | 16795 | 8.9% |
Length
Pie chart
| Value | Count | Frequency (%) |
| arauca | 77309 | |
| tame | 50885 | |
| saravena | 25064 | 13.3% |
| arauquita | 18322 | 9.7% |
| otros | 16795 | 8.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 412970 | |
| R | 120695 | 10.8% |
| U | 113953 | 10.2% |
| C | 77309 | 6.9% |
| E | 75949 | 6.8% |
| T | 69207 | 6.2% |
| M | 50885 | 4.6% |
| S | 25064 | 2.2% |
| V | 25064 | 2.2% |
| N | 25064 | 2.2% |
| Other values (7) | 120619 | 10.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1049599 | |
| Lowercase Letter | 67180 | 6.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 412970 | |
| R | 120695 | 11.5% |
| U | 113953 | 10.9% |
| C | 77309 | 7.4% |
| E | 75949 | 7.2% |
| T | 69207 | 6.6% |
| M | 50885 | 4.8% |
| S | 25064 | 2.4% |
| V | 25064 | 2.4% |
| N | 25064 | 2.4% |
| Other values (3) | 53439 | 5.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 16795 | |
| r | 16795 | |
| o | 16795 | |
| s | 16795 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1116779 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 412970 | |
| R | 120695 | 10.8% |
| U | 113953 | 10.2% |
| C | 77309 | 6.9% |
| E | 75949 | 6.8% |
| T | 69207 | 6.2% |
| M | 50885 | 4.6% |
| S | 25064 | 2.2% |
| V | 25064 | 2.2% |
| N | 25064 | 2.2% |
| Other values (7) | 120619 | 10.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1116779 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 412970 | |
| R | 120695 | 10.8% |
| U | 113953 | 10.2% |
| C | 77309 | 6.9% |
| E | 75949 | 6.8% |
| T | 69207 | 6.2% |
| M | 50885 | 4.6% |
| S | 25064 | 2.2% |
| V | 25064 | 2.2% |
| N | 25064 | 2.2% |
| Other values (7) | 120619 | 10.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| SIN CODEUDOR | |
|---|---|
| CON CODEUDOR |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 2260500 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SIN CODEUDOR |
|---|---|
| 2nd row | SIN CODEUDOR |
| 3rd row | SIN CODEUDOR |
| 4th row | SIN CODEUDOR |
| 5th row | SIN CODEUDOR |
Common Values
| Value | Count | Frequency (%) |
| SIN CODEUDOR | 160888 | |
| CON CODEUDOR | 27487 | 14.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| codeudor | 188375 | |
| sin | 160888 | |
| con | 27487 | 7.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 404237 | |
| D | 376750 | |
| C | 215862 | |
| N | 188375 | |
| 188375 | ||
| E | 188375 | |
| U | 188375 | |
| R | 188375 | |
| S | 160888 | 7.1% |
| I | 160888 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2072125 | |
| Space Separator | 188375 | 8.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 404237 | |
| D | 376750 | |
| C | 215862 | |
| N | 188375 | |
| E | 188375 | |
| U | 188375 | |
| R | 188375 | |
| S | 160888 | 7.8% |
| I | 160888 | 7.8% |
Space Separator
| Value | Count | Frequency (%) |
| 188375 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2072125 | |
| Common | 188375 | 8.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 404237 | |
| D | 376750 | |
| C | 215862 | |
| N | 188375 | |
| E | 188375 | |
| U | 188375 | |
| R | 188375 | |
| S | 160888 | 7.8% |
| I | 160888 | 7.8% |
Common
| Value | Count | Frequency (%) |
| 188375 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2260500 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 404237 | |
| D | 376750 | |
| C | 215862 | |
| N | 188375 | |
| 188375 | ||
| E | 188375 | |
| U | 188375 | |
| R | 188375 | |
| S | 160888 | 7.1% |
| I | 160888 | 7.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 18 |
| Missing (%) | < 0.1% |
| Memory size | 1.4 MiB |
| PRIVADO | |
|---|---|
| PUBLICO |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1318499 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PRIVADO |
|---|---|
| 2nd row | PRIVADO |
| 3rd row | PRIVADO |
| 4th row | PRIVADO |
| 5th row | PRIVADO |
Common Values
| Value | Count | Frequency (%) |
| PRIVADO | 170059 | |
| PUBLICO | 18298 | 9.7% |
| (Missing) | 18 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| privado | 170059 | |
| publico | 18298 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 188357 | |
| I | 188357 | |
| O | 188357 | |
| R | 170059 | |
| V | 170059 | |
| A | 170059 | |
| D | 170059 | |
| U | 18298 | 1.4% |
| B | 18298 | 1.4% |
| L | 18298 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1318499 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 188357 | |
| I | 188357 | |
| O | 188357 | |
| R | 170059 | |
| V | 170059 | |
| A | 170059 | |
| D | 170059 | |
| U | 18298 | 1.4% |
| B | 18298 | 1.4% |
| L | 18298 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1318499 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 188357 | |
| I | 188357 | |
| O | 188357 | |
| R | 170059 | |
| V | 170059 | |
| A | 170059 | |
| D | 170059 | |
| U | 18298 | 1.4% |
| B | 18298 | 1.4% |
| L | 18298 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1318499 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 188357 | |
| I | 188357 | |
| O | 188357 | |
| R | 170059 | |
| V | 170059 | |
| A | 170059 | |
| D | 170059 | |
| U | 18298 | 1.4% |
| B | 18298 | 1.4% |
| L | 18298 | 1.4% |
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.373744 |
| Minimum | 1996 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1996 |
|---|---|
| 5-th percentile | 2001 |
| Q1 | 2009 |
| median | 2014 |
| Q3 | 2017 |
| 95-th percentile | 2019 |
| Maximum | 2021 |
| Range | 25 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.504597939 |
|---|---|
| Coefficient of variation (CV) | 0.002735375552 |
| Kurtosis | 0.01111200062 |
| Mean | 2012.373744 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.8332514127 |
| Sum | 379080904 |
| Variance | 30.30059848 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2015 | 17958 | 9.5% |
| 2017 | 15242 | 8.1% |
| 2014 | 14668 | 7.8% |
| 2018 | 14504 | 7.7% |
| 2016 | 14358 | 7.6% |
| 2013 | 12975 | 6.9% |
| 2012 | 11897 | 6.3% |
| 2011 | 10891 | 5.8% |
| 2019 | 10731 | 5.7% |
| 2010 | 8960 | 4.8% |
| Other values (16) | 56191 |
| Value | Count | Frequency (%) |
| 1996 | 1 | < 0.1% |
| 1997 | 1144 | 0.6% |
| 1998 | 2008 | |
| 1999 | 2670 | |
| 2000 | 2581 | |
| 2001 | 2876 | |
| 2002 | 2824 | |
| 2003 | 2864 | |
| 2004 | 3723 | |
| 2005 | 4629 |
| Value | Count | Frequency (%) |
| 2021 | 532 | 0.3% |
| 2020 | 7602 | |
| 2019 | 10731 | |
| 2018 | 14504 | |
| 2017 | 15242 | |
| 2016 | 14358 | |
| 2015 | 17958 | |
| 2014 | 14668 | |
| 2013 | 12975 | |
| 2012 | 11897 |
mes_credito
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.879909754 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.486528039 |
|---|---|
| Coefficient of variation (CV) | 0.5067694437 |
| Kurtosis | -1.215080083 |
| Mean | 6.879909754 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.111759026 |
| Sum | 1296003 |
| Variance | 12.15587777 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 21540 | |
| 10 | 17814 | |
| 9 | 16137 | |
| 11 | 15901 | |
| 5 | 15731 | |
| 7 | 15607 | |
| 8 | 15203 | |
| 6 | 15036 | |
| 3 | 14397 | |
| 4 | 13864 | |
| Other values (2) | 27145 |
| Value | Count | Frequency (%) |
| 1 | 13442 | |
| 2 | 13703 | |
| 3 | 14397 | |
| 4 | 13864 | |
| 5 | 15731 | |
| 6 | 15036 | |
| 7 | 15607 | |
| 8 | 15203 | |
| 9 | 16137 | |
| 10 | 17814 |
| Value | Count | Frequency (%) |
| 12 | 21540 | |
| 11 | 15901 | |
| 10 | 17814 | |
| 9 | 16137 | |
| 8 | 15203 | |
| 7 | 15607 | |
| 6 | 15036 | |
| 5 | 15731 | |
| 4 | 13864 | |
| 3 | 14397 |
| Distinct | 667 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 67.49130192 |
| Minimum | 0 |
|---|---|
| Maximum | 700 |
| Zeros | 1577 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 19 |
| median | 45 |
| Q3 | 78 |
| 95-th percentile | 229 |
| Maximum | 700 |
| Range | 700 |
| Interquartile range (IQR) | 59 |
Descriptive statistics
| Standard deviation | 80.92823993 |
|---|---|
| Coefficient of variation (CV) | 1.199091403 |
| Kurtosis | 15.35489601 |
| Mean | 67.49130192 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 3.246158355 |
| Sum | 12713674 |
| Variance | 6549.380018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 4471 | 2.4% |
| 7 | 3928 | 2.1% |
| 16 | 2966 | 1.6% |
| 15 | 2717 | 1.4% |
| 8 | 2674 | 1.4% |
| 18 | 2628 | 1.4% |
| 5 | 2598 | 1.4% |
| 17 | 2587 | 1.4% |
| 14 | 2367 | 1.3% |
| 19 | 2257 | 1.2% |
| Other values (657) | 159182 |
| Value | Count | Frequency (%) |
| 0 | 1577 | 0.8% |
| 1 | 2207 | |
| 2 | 2156 | |
| 3 | 1557 | 0.8% |
| 4 | 1769 | 0.9% |
| 5 | 2598 | |
| 6 | 4471 | |
| 7 | 3928 | |
| 8 | 2674 | |
| 9 | 2101 |
| Value | Count | Frequency (%) |
| 700 | 447 | |
| 698 | 1 | < 0.1% |
| 697 | 2 | < 0.1% |
| 696 | 1 | < 0.1% |
| 695 | 2 | < 0.1% |
| 694 | 2 | < 0.1% |
| 693 | 2 | < 0.1% |
| 691 | 2 | < 0.1% |
| 689 | 1 | < 0.1% |
| 687 | 1 | < 0.1% |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| PAGADO VENCIDO | |
|---|---|
| PAGADO ANTICIPADO | |
| PAGADO A TIEMPO | |
| DESCUENTO EN VENTA | |
| CARTERA CASTIGADA | 4028 |
| Other values (2) | 4425 |
Length
| Max length | 18 |
|---|---|
| Median length | 14 |
| Mean length | 15.21375979 |
| Min length | 10 |
Characters and Unicode
| Total characters | 2865892 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PAGADO ANTICIPADO |
|---|---|
| 2nd row | PAGADO ANTICIPADO |
| 3rd row | PAGADO ANTICIPADO |
| 4th row | PAGADO VENCIDO |
| 5th row | PAGADO VENCIDO |
Common Values
| Value | Count | Frequency (%) |
| PAGADO VENCIDO | 94541 | |
| PAGADO ANTICIPADO | 49231 | |
| PAGADO A TIEMPO | 21853 | 11.6% |
| DESCUENTO EN VENTA | 14297 | 7.6% |
| CARTERA CASTIGADA | 4028 | 2.1% |
| OTROS CIERRES | 2508 | 1.3% |
| DEVOLUCION | 1917 | 1.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| pagado | 165625 | |
| vencido | 94541 | |
| anticipado | 49231 | 12.0% |
| a | 21853 | 5.3% |
| tiempo | 21853 | 5.3% |
| en | 14297 | 3.5% |
| descuento | 14297 | 3.5% |
| venta | 14297 | 3.5% |
| cartera | 4028 | 1.0% |
| castigada | 4028 | 1.0% |
| Other values (3) | 6933 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 486002 | |
| O | 354397 | |
| D | 329639 | |
| P | 236709 | |
| I | 223309 | |
| 222608 | ||
| N | 188580 | 6.6% |
| E | 184543 | 6.4% |
| C | 170550 | 6.0% |
| G | 169653 | 5.9% |
| Other values (7) | 299902 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2643284 | |
| Space Separator | 222608 | 7.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 486002 | |
| O | 354397 | |
| D | 329639 | |
| P | 236709 | |
| I | 223309 | |
| N | 188580 | 7.1% |
| E | 184543 | 7.0% |
| C | 170550 | 6.5% |
| G | 169653 | 6.4% |
| V | 110755 | 4.2% |
| Other values (6) | 189147 | 7.2% |
Space Separator
| Value | Count | Frequency (%) |
| 222608 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2643284 | |
| Common | 222608 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 486002 | |
| O | 354397 | |
| D | 329639 | |
| P | 236709 | |
| I | 223309 | |
| N | 188580 | 7.1% |
| E | 184543 | 7.0% |
| C | 170550 | 6.5% |
| G | 169653 | 6.4% |
| V | 110755 | 4.2% |
| Other values (6) | 189147 | 7.2% |
Common
| Value | Count | Frequency (%) |
| 222608 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2865892 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 486002 | |
| O | 354397 | |
| D | 329639 | |
| P | 236709 | |
| I | 223309 | |
| 222608 | ||
| N | 188580 | 6.6% |
| E | 184543 | 6.4% |
| C | 170550 | 6.0% |
| G | 169653 | 5.9% |
| Other values (7) | 299902 |
tipo_venta
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| ELECTRODOMESTICOS | |
|---|---|
| MOTOS | 871 |
| CONTRATO | 26 |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.94327273 |
| Min length | 5 |
Characters and Unicode
| Total characters | 3191689 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ELECTRODOMESTICOS |
|---|---|
| 2nd row | ELECTRODOMESTICOS |
| 3rd row | ELECTRODOMESTICOS |
| 4th row | ELECTRODOMESTICOS |
| 5th row | ELECTRODOMESTICOS |
Common Values
| Value | Count | Frequency (%) |
| ELECTRODOMESTICOS | 187478 | |
| MOTOS | 871 | 0.5% |
| CONTRATO | 26 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| electrodomesticos | 187478 | |
| motos | 871 | 0.5% |
| contrato | 26 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 564228 | |
| E | 562434 | |
| T | 375879 | |
| S | 375827 | |
| C | 374982 | |
| M | 188349 | 5.9% |
| R | 187504 | 5.9% |
| L | 187478 | 5.9% |
| D | 187478 | 5.9% |
| I | 187478 | 5.9% |
| Other values (2) | 52 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3191689 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 564228 | |
| E | 562434 | |
| T | 375879 | |
| S | 375827 | |
| C | 374982 | |
| M | 188349 | 5.9% |
| R | 187504 | 5.9% |
| L | 187478 | 5.9% |
| D | 187478 | 5.9% |
| I | 187478 | 5.9% |
| Other values (2) | 52 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3191689 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 564228 | |
| E | 562434 | |
| T | 375879 | |
| S | 375827 | |
| C | 374982 | |
| M | 188349 | 5.9% |
| R | 187504 | 5.9% |
| L | 187478 | 5.9% |
| D | 187478 | 5.9% |
| I | 187478 | 5.9% |
| Other values (2) | 52 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3191689 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 564228 | |
| E | 562434 | |
| T | 375879 | |
| S | 375827 | |
| C | 374982 | |
| M | 188349 | 5.9% |
| R | 187504 | 5.9% |
| L | 187478 | 5.9% |
| D | 187478 | 5.9% |
| I | 187478 | 5.9% |
| Other values (2) | 52 | < 0.1% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| MENSUAL(ES) | |
|---|---|
| DIARIA(S) | 9973 |
| SEMANAL(ES) | 1765 |
| QUINCENAL(ES) | 621 |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 10.90070869 |
| Min length | 9 |
Characters and Unicode
| Total characters | 2053421 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | QUINCENAL(ES) |
|---|---|
| 2nd row | MENSUAL(ES) |
| 3rd row | MENSUAL(ES) |
| 4th row | MENSUAL(ES) |
| 5th row | MENSUAL(ES) |
Common Values
| Value | Count | Frequency (%) |
| MENSUAL(ES) | 176016 | |
| DIARIA(S) | 9973 | 5.3% |
| SEMANAL(ES) | 1765 | 0.9% |
| QUINCENAL(ES) | 621 | 0.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| mensual(es | 176016 | |
| diaria(s | 9973 | 5.3% |
| semanal(es | 1765 | 0.9% |
| quincenal(es | 621 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 366156 | |
| E | 356804 | |
| A | 200113 | |
| ( | 188375 | |
| ) | 188375 | |
| N | 179023 | |
| L | 178402 | |
| M | 177781 | |
| U | 176637 | |
| I | 20567 | 1.0% |
| Other values (4) | 21188 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1676671 | |
| Open Punctuation | 188375 | 9.2% |
| Close Punctuation | 188375 | 9.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 366156 | |
| E | 356804 | |
| A | 200113 | |
| N | 179023 | |
| L | 178402 | |
| M | 177781 | |
| U | 176637 | |
| I | 20567 | 1.2% |
| D | 9973 | 0.6% |
| R | 9973 | 0.6% |
| Other values (2) | 1242 | 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 188375 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 188375 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1676671 | |
| Common | 376750 | 18.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 366156 | |
| E | 356804 | |
| A | 200113 | |
| N | 179023 | |
| L | 178402 | |
| M | 177781 | |
| U | 176637 | |
| I | 20567 | 1.2% |
| D | 9973 | 0.6% |
| R | 9973 | 0.6% |
| Other values (2) | 1242 | 0.1% |
Common
| Value | Count | Frequency (%) |
| ( | 188375 | |
| ) | 188375 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2053421 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 366156 | |
| E | 356804 | |
| A | 200113 | |
| ( | 188375 | |
| ) | 188375 | |
| N | 179023 | |
| L | 178402 | |
| M | 177781 | |
| U | 176637 | |
| I | 20567 | 1.0% |
| Other values (4) | 21188 | 1.0% |
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.143824818 |
| Minimum | 0 |
|---|---|
| Maximum | 14 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 4 |
| Q3 | 10 |
| 95-th percentile | 14 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 4.455517642 |
|---|---|
| Coefficient of variation (CV) | 0.8661876716 |
| Kurtosis | -0.9937509874 |
| Mean | 5.143824818 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.6628625532 |
| Sum | 968968 |
| Variance | 19.85163746 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 71980 | |
| 10 | 22823 | 12.1% |
| 5 | 14877 | 7.9% |
| 14 | 14166 | 7.5% |
| 3 | 10925 | 5.8% |
| 6 | 10582 | 5.6% |
| 2 | 10577 | 5.6% |
| 12 | 8188 | 4.3% |
| 4 | 8026 | 4.3% |
| 9 | 5644 | 3.0% |
| Other values (5) | 10587 | 5.6% |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 71980 | |
| 2 | 10577 | 5.6% |
| 3 | 10925 | 5.8% |
| 4 | 8026 | 4.3% |
| 5 | 14877 | 7.9% |
| 6 | 10582 | 5.6% |
| 7 | 2007 | 1.1% |
| 8 | 4061 | 2.2% |
| 9 | 5644 | 3.0% |
| Value | Count | Frequency (%) |
| 14 | 14166 | |
| 13 | 624 | 0.3% |
| 12 | 8188 | 4.3% |
| 11 | 3893 | 2.1% |
| 10 | 22823 | |
| 9 | 5644 | 3.0% |
| 8 | 4061 | 2.2% |
| 7 | 2007 | 1.1% |
| 6 | 10582 | |
| 5 | 14877 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| CRÉDITO | |
|---|---|
| LIBRANZA | 5858 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.031097545 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1324483 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CRÉDITO |
|---|---|
| 2nd row | CRÉDITO |
| 3rd row | CRÉDITO |
| 4th row | CRÉDITO |
| 5th row | CRÉDITO |
Common Values
| Value | Count | Frequency (%) |
| CRÉDITO | 182517 | |
| LIBRANZA | 5858 | 3.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| crédito | 182517 | |
| libranza | 5858 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 188375 | |
| I | 188375 | |
| C | 182517 | |
| É | 182517 | |
| D | 182517 | |
| T | 182517 | |
| O | 182517 | |
| A | 11716 | 0.9% |
| L | 5858 | 0.4% |
| B | 5858 | 0.4% |
| Other values (2) | 11716 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1324483 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 188375 | |
| I | 188375 | |
| C | 182517 | |
| É | 182517 | |
| D | 182517 | |
| T | 182517 | |
| O | 182517 | |
| A | 11716 | 0.9% |
| L | 5858 | 0.4% |
| B | 5858 | 0.4% |
| Other values (2) | 11716 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1324483 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 188375 | |
| I | 188375 | |
| C | 182517 | |
| É | 182517 | |
| D | 182517 | |
| T | 182517 | |
| O | 182517 | |
| A | 11716 | 0.9% |
| L | 5858 | 0.4% |
| B | 5858 | 0.4% |
| Other values (2) | 11716 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1141966 | |
| Latin 1 Sup | 182517 | 13.8% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 188375 | |
| I | 188375 | |
| C | 182517 | |
| D | 182517 | |
| T | 182517 | |
| O | 182517 | |
| A | 11716 | 1.0% |
| L | 5858 | 0.5% |
| B | 5858 | 0.5% |
| N | 5858 | 0.5% |
Latin 1 Sup
| Value | Count | Frequency (%) |
| É | 182517 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| DUDOSO | |
|---|---|
| APTO | |
| ACEPTABLE | |
| NEGATIVO | 4028 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.555689449 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1046553 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | APTO |
|---|---|
| 2nd row | APTO |
| 3rd row | APTO |
| 4th row | DUDOSO |
| 5th row | DUDOSO |
Common Values
| Value | Count | Frequency (%) |
| DUDOSO | 96458 | |
| APTO | 71084 | |
| ACEPTABLE | 16805 | 8.9% |
| NEGATIVO | 4028 | 2.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| dudoso | 96458 | |
| apto | 71084 | |
| aceptable | 16805 | 8.9% |
| negativo | 4028 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 268028 | |
| D | 192916 | |
| A | 108722 | |
| U | 96458 | 9.2% |
| S | 96458 | 9.2% |
| T | 91917 | 8.8% |
| P | 87889 | 8.4% |
| E | 37638 | 3.6% |
| C | 16805 | 1.6% |
| B | 16805 | 1.6% |
| Other values (5) | 32917 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1046553 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 268028 | |
| D | 192916 | |
| A | 108722 | |
| U | 96458 | 9.2% |
| S | 96458 | 9.2% |
| T | 91917 | 8.8% |
| P | 87889 | 8.4% |
| E | 37638 | 3.6% |
| C | 16805 | 1.6% |
| B | 16805 | 1.6% |
| Other values (5) | 32917 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1046553 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 268028 | |
| D | 192916 | |
| A | 108722 | |
| U | 96458 | 9.2% |
| S | 96458 | 9.2% |
| T | 91917 | 8.8% |
| P | 87889 | 8.4% |
| E | 37638 | 3.6% |
| C | 16805 | 1.6% |
| B | 16805 | 1.6% |
| Other values (5) | 32917 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1046553 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 268028 | |
| D | 192916 | |
| A | 108722 | |
| U | 96458 | 9.2% |
| S | 96458 | 9.2% |
| T | 91917 | 8.8% |
| P | 87889 | 8.4% |
| E | 37638 | 3.6% |
| C | 16805 | 1.6% |
| B | 16805 | 1.6% |
| Other values (5) | 32917 | 3.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Row | procedencia | genero | estado_civil | edad | municipio_residencia | municipio_nacimiento | municipio_expedicion | tipo_persona | tiene_casa_propia | sueldo_smdlv | otros_ingresos | otros_ingresos_smdlv | municipio_credito | codeudor | sector | año_credito | mes_credito | valor_credito_smdlv | estado_final | tipo_venta | periodo_credito | cuotas | forma_pago | tipo_cliente | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | Nacional | NaN | NaN | NaN | SARAVENA | NaN | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | SARAVENA | SIN CODEUDOR | PRIVADO | 2020 | 12 | 356 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | QUINCENAL(ES) | 1 | CRÉDITO | APTO |
| 1 | 2 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | SARAVENA | SIN CODEUDOR | PRIVADO | 2008 | 5 | 118 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 10 | CRÉDITO | APTO |
| 2 | 3 | Nacional | NaN | Union Libre | 57.0 | ARAUCA | ARAUCA | ARAUCA | Natural | No | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2014 | 11 | 59 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 10 | CRÉDITO | APTO |
| 3 | 4 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | SARAVENA | SIN CODEUDOR | PRIVADO | 2012 | 2 | 22 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 4 | CRÉDITO | DUDOSO |
| 4 | 5 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUQUITA | SIN CODEUDOR | PRIVADO | 2013 | 7 | 50 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 7 | CRÉDITO | DUDOSO |
| 5 | 6 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUQUITA | SIN CODEUDOR | PRIVADO | 2010 | 12 | 41 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 5 | CRÉDITO | DUDOSO |
| 6 | 7 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUQUITA | SIN CODEUDOR | PRIVADO | 2010 | 8 | 78 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 8 | CRÉDITO | DUDOSO |
| 7 | 8 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | SARAVENA | SIN CODEUDOR | PRIVADO | 2012 | 8 | 76 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | MENSUAL(ES) | 8 | CRÉDITO | APTO |
| 8 | 9 | Nacional | NaN | NaN | NaN | SARAVENA | ARAUCA | ARAUCA | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | SARAVENA | SIN CODEUDOR | PRIVADO | 2014 | 12 | 7 | PAGADO VENCIDO | ELECTRODOMESTICOS | MENSUAL(ES) | 2 | CRÉDITO | DUDOSO |
| 9 | 10 | Nacional | NaN | Union Libre | 57.0 | ARAUCA | ARAUCA | ARAUCA | Natural | No | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2015 | 9 | 7 | PAGADO A TIEMPO | ELECTRODOMESTICOS | MENSUAL(ES) | 1 | CRÉDITO | APTO |
Last rows
| Row | procedencia | genero | estado_civil | edad | municipio_residencia | municipio_nacimiento | municipio_expedicion | tipo_persona | tiene_casa_propia | sueldo_smdlv | otros_ingresos | otros_ingresos_smdlv | municipio_credito | codeudor | sector | año_credito | mes_credito | valor_credito_smdlv | estado_final | tipo_venta | periodo_credito | cuotas | forma_pago | tipo_cliente | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188365 | 188366 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2007 | 8 | 7 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 10 | CRÉDITO | DUDOSO |
| 188366 | 188367 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2005 | 8 | 235 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 14 | CRÉDITO | DUDOSO |
| 188367 | 188368 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 1997 | 12 | 27 | CARTERA CASTIGADA | ELECTRODOMESTICOS | SEMANAL(ES) | 4 | CRÉDITO | NEGATIVO |
| 188368 | 188369 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2007 | 3 | 20 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | SEMANAL(ES) | 10 | CRÉDITO | APTO |
| 188369 | 188370 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2004 | 5 | 8 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 7 | CRÉDITO | DUDOSO |
| 188370 | 188371 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2000 | 5 | 106 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 14 | CRÉDITO | DUDOSO |
| 188371 | 188372 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 1999 | 11 | 55 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 14 | CRÉDITO | DUDOSO |
| 188372 | 188373 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2005 | 12 | 15 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 9 | CRÉDITO | DUDOSO |
| 188373 | 188374 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2006 | 1 | 42 | PAGADO VENCIDO | ELECTRODOMESTICOS | SEMANAL(ES) | 8 | CRÉDITO | DUDOSO |
| 188374 | 188375 | Nacional | NaN | NaN | NaN | ARAUCA | ARAUCA | NaN | Natural | NaN | NaN | SIN OTROS INGRESOS | NaN | ARAUCA | SIN CODEUDOR | PRIVADO | 2008 | 12 | 31 | PAGADO ANTICIPADO | ELECTRODOMESTICOS | SEMANAL(ES) | 1 | CRÉDITO | APTO |